1. Each CD may have many pieces of music recording; list the CDs with more than 7 pieces of music recording. List CDNo, CD Name, and the number of music pieces, and list those with more music pieces first, that is, in descending order. 2. List the Composers born before 1600 who also composed music pieces in the library. List the composers by First name and Last name, but do not show duplicates. List them in alphabetical order by Last name, and for those with same Last name, by First name. 3. List the Composers who have at least 9 music pieces in the library. List the First name and the Last name of the composers, in the descending order of the number of music pieces done. (i.e., list the composer with most pieces first, and in that order). 4. List the Composers who have no music pieces in the library. List the First name and then the Last name of the composers, but in alphabetical order by the last name, and then by the first name, for those with the same last name. 5. List the Composers born in the 17th century (i.e., born between 1600 and 1699) along with the number of music pieces each one composed. List these composers by First name, Last name, and number of pieces of music done. If a composer has no music pieces in the library, the composer should still be listed, but with 0 for the number of pieces. List the composers by descending order of number of music pieces. 6. If there are different music Pieces (with different PNo) done by different Composers (with different CNo), and the music Pieces have the exact same title, list the titles of these music pieces. List just each of these titles once, in alphabetical order, showing no duplicates. 7. If there are different music Pieces (with different PNo) done by different Composers (with different CNo), and the music Pieces have the exact same title, list the titles of these music pieces, by the number of times the title was composed by different composers; list each title along with the composer's first and last names. Therefore, the result should contain no duplicate rows.